<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta name="generator" content="HTML Tidy, see www.w3.org">
<title></title>
</head>
<body>
<table summary="FAQ Table" border="0" cellpadding="0" cellspacing="0"
	width="100%">
	<tr>
		<td width='10' height='10'><img alt="border image" border="0"
			src="images/border_tl.gif" width="10" height="10"></td>
		<td width='100%' height='10'><img alt="border image" border="0"
			src="images/border_t.gif" width="100%" height="10"></td>
		<td width='10' height='10'><img alt="border image" border="0"
			src="images/border_tr.gif" width="10" height="10"></td>
	</tr>

	<tr>
		<td class="body_left_border">&nbsp;</td>
		<td width='100%' bgcolor="white" valign="top">
		<h1 class="body">FAQ - SQuirreL SQL Client.</h1>

		<p></p>

		<ul>
			<li><a href="#faq13">I removed the directory where SQuirreL
			was installed, and installed it into a new location. I was surprised
			to see all of my alias, drivers and preference settings were
			maintained when I launched SQuirreL from the new location. Where are
			alias, driver and preference configurations persisted?</a>
			<li><a href="#faq12">Is there a way to configure Squirrel to
			show integers without commas? We use integer IDs that look like
			1000234. Squirrel is currently showing the ID as 1,000,234</a>
			<li><a href="#faq11">I don't see Oracle system tables/views
			list in the code completion dialog. Can I configure this somehow?</a></li>

			<li><a href="#faq10">How do I install SQuirreL SQL Client on
			Windows Vista?</a></li>

			<li><a href="#faq9">I get a blank window when running
			SQuirreL on Fedora Core while using Desktop Effects (Compiz) and the
			Sun JDK.</a></li>

			<li><a href="#faq0">What database systems does SQuirreL work
			with?</a></li>

			<li><a href="#faq1">What version of the JVM is SQuirreL
			compatible with?</a></li>

			<li><a href="#faq2">I get a "Segmentation fault" on Linux</a></li>

			<li><a href="#faq3">I get a "Login has timed out" error with
			Microsoft SQL Server</a></li>

			<li><a href="#faq3_1">I get a "Can't start a cloned
			connection while in manual transaction mode" error with Microsoft SQL
			Server</a></li>

			<li><a href="#faq4">I don't see an object tree with
			PostgreSQL</a></li>

			<li><a href="#faq5">I get a "NullPointerException" at <tt>BaseSQLEntryPanel.java:23</tt></a></li>

			<li><a href="#faq6">Ingres reports "Error: contsbt:
			ca.edbc.util.EdbcEx: No MST is currently in progress, cannot declare
			another cursor." when I connect and nothing is listed under the
			schema name in the Object Tree.</a></li>

			<li><a href="#faq7">Informix reports "The specified table
			(schema.table) is not in the database" when trying to view the
			contents of a table in the current schema.</a></li>

			<li><a href="#faq8">I am using SQuirreL 2.x and when I
			connect to a database I get the following warning message:</a></li>
		</ul>

		<pre>
        JRE/JDBC Version mismatch

        The driver being used ... is not JDBC N.N compliant. 
        You should consider getting a more recent version of this driver.
       
</pre> <br>
		</td>
		<td class="body_right_border">&nbsp;</td>
	</tr>

	<tr>
		<td width='10' height='10'><img alt="border image" border="0"
			src="images/border_bl.gif" width="10" height="10"></td>
		<td width='100%' height='10'><img alt="border image" border="0"
			src="images/border_b.gif" width="100%" height="10"></td>
		<td width='10' height='10'><img alt="border image" border="0"
			src="images/border_br.gif" width="10" height="10"></td>
	</tr>
</table>

<p class="menu_divider">
<table summary="Plugin Section" border="0" cellpadding="0"
	cellspacing="0" width="100%">
	<tr>
		<td width='10' height='10'><img alt="border image" border="0"
			src="images/border_tl.gif" width="10" height="10"></td>
		<td width='100%' height='10'><img alt="border image" border="0"
			src="images/border_t.gif" width="100%" height="10"></td>
		<td width='10' height='10'><img alt="border image" border="0"
			src="images/border_tr.gif" width="10" height="10"></td>
	</tr>

	<tr>
		<td class="body_left_border">&nbsp;</td>
		<td width='100%' bgcolor="white" valign="top">
		<h1 class="body">FAQ - Plugins.</h1>

		<br>


		<ul>
			<li><a href="#plug0">How do I write a plugin?</a></li>

			<li><a href="#plug1">What are these directories "Colin Bell"
			and "Johan Compagner" in the plugins directory?</a></li>

			<li><a href="#plug2">I can't see any "Look and Feel" files.</a></li>

			<li><a href="#plug3">I get a <tt>java.lang.NoClassDefFoundError:
			org/w3c/dom/Node</tt> error when trying to validate SQL.</a></li>
		</ul>

		<br>
		</td>
		<td class="body_right_border">&nbsp;</td>
	</tr>

	<tr>
		<td width='10' height='10'><img alt="border image" border="0"
			src="images/border_bl.gif" width="10" height="10"></td>
		<td width='100%' height='10'><img alt="border image" border="0"
			src="images/border_b.gif" width="100%" height="10"></td>
		<td width='10' height='10'><img alt="border image" border="0"
			src="images/border_br.gif" width="10" height="10"></td>
	</tr>
</table>

<p class="menu_divider">
<table summary="Answers" border="0" cellpadding="0" cellspacing="0"
	width="100%">
	<tr>
		<td width='10' height='10'><img alt="border image" border="0"
			src="images/border_tl.gif" width="10" height="10"></td>
		<td width='100%' height='10'><img alt="border image" border="0"
			src="images/border_t.gif" width="100%" height="10"></td>
		<td width='10' height='10'><img alt="border image" border="0"
			src="images/border_tr.gif" width="10" height="10"></td>
	</tr>

	<tr>
		<td class="body_left_border">&nbsp;</td>
		<td width='100%' bgcolor="white" valign="top">
		<h1 class="body">Answers - SQuirreL SQL Client.</h1>


		<h1 class="question"><a name="faq13">I removed the directory
		where SQuirreL was installed, and installed it into a new location. I
		was surprised to see all of my alias, drivers and preference settings
		were maintained when I launched SQuirreL from the new location. Where
		are alias, driver and preference configurations persisted?</a></h1>

		<div class="answer">All preference data is stored in the <user.home>/.squirrel-sql/
		folder. The <user.home> folder is typically /home/<username>
		on UNIX and C:\Documents and Settings\<username> on
		Windows. The aliases are stored in SQLAliases23.xml and
		SQLAliases23_treeStructure.xml, while the driver definitions are found
		in SQLDrivers.xml. Other preference data is also stored in various
		files in this directory.</div>

		<h1 class="question"><a name="faq12">Is there a way to
		configure Squirrel to show integers without commas? We use integer IDs
		that look like 1000234. Squirrel is currently showing the ID as
		1,000,234.</a></h1>

		<div class="answer">Yes there is. Open Global Preferences from
		the File menu and then click on Data Type Control tab. Scroll down to
		the bottom. Scroll down to the "FLOAT, REAL, DOUBLE, NUMERIC" section,
		select "Use default format".</div>

		<h1 class="question"><a name="faq11">I don't see Oracle
		system tables/views list in the code completion dialog. Can I
		configure this somehow?</a></h1>

		<div class="answer">For startup performance, fine-grain control
		was introduced to allow you to specify which schemas are loaded. This
		is a big deal for Oracle as it has by default many schemas which are
		rarely used and some that are used occasionally that have tons of
		objects in them (e.g. SYS). You can control this configuration per
		alias as follows:

		<ol>
			<li>Right-click on the alias and choose "Alias Properties".</li>

			<li>In the "Schemas" tab of the resulting dialog, choose
			"Specify Schema loading and caching".</li>

			<li>Click the "Connect database to refresh Schema table"
			button.(Now, for each schema listed you are able to specify whether
			or not tables, views and/or procedures are loaded into the object
			tree, by clicking the cell in Tables, Views, or Procedures.</li>

			<li>Turn off all schemas and then explicitly add the ones you
			need for this particular alias. You can achieve this easily with the
			buttons below the schema table. It forms a sentence that should read
			"Set &lt;All Objects&gt; in all Schemas to &lt;Don't load&gt;", then
			click Apply. All Table, View and Procedure cells move to "Don't load"
			value.</li>

			<li>Find your schema and change the Tables, Views and Procedures
			cells for that row to "Load ..." (caching will help if you have a
			large number of objects that are always present)</li>

			<li>Next find the SYS schema and change it to load VIEWS.</li>

			<li>Start a new session with that alias and SYS views will be
			loaded into the object tree of that new session</li>
		</ol>
		</div>

		<h1 class="question"><a name="faq10">How do I install
		SQuirreL SQL Client on Windows Vista?</a></h1>

		<p class="answer">Doug Lawry has reported that the following steps
		are required in order to install SQuirreL SQL Client on Windows Vista.<br>
		</p>

		<ol>
			<li>Start "cmd.exe" using "Run as administrator"</li>

			<li>Change directory to the file location</li>

			<li>Run "java -jar squirrel-sql-2.5.1-install.jar"</li>
		</ol>

		<h1 class="question"><a name="faq9">I get a blank SQuirreL
		2.4 window when running on Fedora Core while using Desktop Effects
		(Compiz) and Sun Java 1.5. What gives?</a></h1>

		<p class="answer">Andrew Melton has reported that disabling
		Desktop Effects (and using metacity) solved the problem. Furthermore,
		he also reports that after re-enabling Desktop Effects SQuirreL still
		renders correctly. Additionally, <a
			href="http://bugs.sun.com/bugdatabase/view_bug.do?bug_id=6429775">this
		Java bug</a> seems to be at least related to if not the same problem.</p>

		<h1 class="question"><a name="faq0">What database systems
		does SQuirreL work with?</a></h1>

		<p class="answer">In theory SQuirreL should work with any DBMS
		that has a JDBC 2.0 driver. However not all drivers/DBMS's are fully
		complient with the JDBC 2.0 specification. People have reported
		SQuirreL working with the following:</p>

		<ul>
			<li><a href="http://axion.tigris.org/">Axion Java RDBMS</a>.</li>

			<li><a href="http://www.daffodildb.com/one-dollar-db.html">Daffodil
			(One$DB)</a></li>

			<li><a href="http://db.apache.org/derby/">Apache Derby</a>
			(formerly Cloudscape) <a
				href="http://db.apache.org/derby/integrate/SQuirreL_Derby.html">Using
			SQuirreL SQL with Derby</a> (by Susan Cline)</li>

			<li><a
				href="http://www.fujitsu-siemens.com/rl/products/software/sesamsql.html">
			Fujitsu Siemens SESAM/SQL-Server</a> with the <a
				href="http://www.fujitsu-siemens.com/rl/products/software/sesamsqljdbc.html">
			SESAM/SQL</a> JDBC driver.</li>

			<li><a href="http://sourceforge.net/projects/firebird/">Firebird</a>
			with the JayBird JCA/JDBC Driver.</li>

			<li><a href="http://www.frontbase.com/">FrontBase</a></li>

			<li><a href="http://hsqldb.sourceforge.net/">HSQL</a>.</li>

			<li><a href="http://hsql.sourceforge.net/">Hypersonic SQL</a>.</li>

			<li><a href="http://www.h2database.com/">H2</a></li>

			<li><a href="http://www.ibm.com/">IBM DB2</a> for Linux, OS/400
			and Windows.</li>

			<li><a href="http://www.informix.com/">Informix</a>.</li>

			<li><a href="http://www.ingres.com/">CA Ingres</a> 2.6 SP2 with
			EDBC driver v1.8 (probably works with Caribou Lake driver too).</li>

			<li><a href="http://www.instantdb.com/">InstantDB</a>.</li>

			<li><a href="http://www.interbase.com/">Interbase</a> with the <a
				href="http://www.interbase.com/">Interclient</a> JDBC driver.</li>

			<li><a href="http://mckoi.com/database/">Mckoi SQL</a>.</li>

			<li><a href="http://www.microsoft.com">Microsoft Access</a> with
			the JDBC/ODBC bridge.</li>

			<li><a href="http://www.microsoft.com">Microsoft SQL Server</a>
			with the Microsoft, <a href="http://www.weblogic.com">WebLogic</a>
			and <a href="http://jtds.sourceforge.net">jTDS</a> JDBC drivers.</li>

			<li><a href="http://www.mimer.com/">Mimer SQL</a></li>

			<li><a href="http://www.mysql.com">MySQL</a> with the <a
				href="http://mmmysql.sourceforge.net/">MM MySQL</a> JDBC driver.</li>

			<li><a href="http://www.netezza.com">Netezza</a> Data Warehouse
			with 4.0.4P2 Driver</li>

			<li><a href="http://www.oracle.com">Oracle 8i, 9i and 10g</a>
			with the Oracle thin and OCI drivers.</li>

			<li><a href="http://www.pointbase.com">Pointbase</a>.</li>

			<li><a href="http://www.postgresql.org">PostgreSQL 7.1.3 and
			higher.</a>.</li>

			<li><a href="http://www.progress.com">Progress OpenEdge
			10.1x</a>.</li>

			<li><a href="http://www.sapdb.org">SAPDB</a>.</li>

			<li><a href="http://www.sybase.com">Sybase</a> with the <a
				href="http://www.sybase.com">JConnect</a> JDBC driver. There are
			currently some issues with Sybase JConnect 5.5 and SQuirreL 1.1
			although JConnect 4.5 seems to work.</li>

			<li><a
				href="http://www.ncr.com/en/solutions/data_warehousing/dataware.htm">Teradata
			Warehouse</a></li>

			<li><a href="http://www.thinksql.co.uk">ThinkSQL RDBMS</a>.</li>

			<li><a href="http://www.vertica.com">Vertica</a> Analytic
			Database</li>
		</ul>

		<p class="answer">Please send us an <a
			href="mailto:manningr@users.sourceforge.net">email</a> if you have
		used SQuirreL successfully with other products.</p>

		<p><a href="#top">Top</a></p>

		<h1 class="question"><a name="faq1">Which version of the JVM
		is SQuirreL compatible with?</a></h1>

		<p class="answer">Different versions of SQuirreL have different
		minimum JVM version requirements. The following table provides a
		summary of the version requirements:<br>
		</p>

		<table align="center" border="2" cellpadding="5"
			summary="Compatibility Matrix">
			<tr>
				<th>SQuirreL Version</th>
				<th>Minimum JVM Version</th>
			</tr>

			<tr align="center">
				<td>3.0+</td>
				<td>1.6</td>
			</tr>

			<tr align="center">
				<td>2.4 - 2.6.x</td>
				<td>1.5</td>
			</tr>

			<tr align="center">
				<td>2.0 - 2.3.x</td>
				<td>1.4.2</td>
			</tr>

			<tr align="center">
				<td>1.1 Final</td>
				<td>1.3.1</td>
			</tr>
		</table>

		<p><a href="#top">Top</a></p>

		<h1 class="question"><a name="faq2">I get a "Segmentation
		fault" on Linux</a></h1>

		<p class="answer">Early versions of the Sun 1.3.0 VM on Linux
		throw a segmentation fault when running SQuirreL. Either update to the
		latest 1.3.1 VM or pass the -classic flag to the Java executable -
		i.e.</p>

		<p class="code">java -classic -cp...</p>

		<p><a href="#top">Top</a></p>

		<h1 class="question"><a name="faq3">I get a "Login has timed
		out" error with Microsoft SQL Server</a></h1>

		<p class="answer">Early beta versions of the Microsoft type 4 JDBC
		driver had a bug which would cause this error when trying to connect.
		Go to the General Tab in the Global Preferences dialog and change the
		SQL Login Timeout to 0.</p>

		<p><a href="#top">Top</a></p>

		<h1 class="question"><a name="faq3_1">I get a "Can't start a
		cloned connection while in manual transaction mode" error with
		Microsoft SQL Server</a></h1>

		<p class="answer">When connecting to Microsoft SQL Server with
		auto-commit off or changing auto-commit to false for an existing
		connection you may get this error. To stop it from occuring enable the
		'selectmethod=cursor' driver property in the alias.</p>

		<p><a href="#top">Top</a></p>

		<h1 class="question"><a name="faq4">I don't see an object
		tree with PostgreSQL</a></h1>

		<p class="answer">Versions of PostgreSQL prior to 7.1.3 didn't
		supply sufficent metadata to build the object tree in SQuirreL. A fix
		has been put into SQuirreL so that it would work with PostgreSQL
		7.1.2.</p>

		<p><a href="#top">Top</a></p>

		<h1 class="question"><a name="faq5">I get a
		"NullPointerException" at <tt>BaseSQLEntryPanel.java:23</tt></a></h1>

		<p class="answer">This is a known problem with JDK1.3.0 on some
		platforms. Upgrade your Java version to 1.3.1 or better.</p>

		<p><a href="#top">Top</a></p>

		<h1 class="question"><a name="faq6">Ingres reports "Error:
		contsbt: ca.edbc.util.EdbcEx: No MST is currently in progress, cannot
		declare another cursor." when I connect and nothing is listed under
		the schema name in the Object Tree</a></h1>

		<p class="answer">Right-click on the schema in the explorer and
		select refresh, objects should appear as normal.</p>

		<p><a href="#top">Top</a></p>

		<h1 class="question"><a name="faq7">Informix reports "The
		specified table (schema.table) is not in the database" when trying to
		view the contents of a table in the current schema</a></h1>

		<p class="answer">This is a bug in earlier versions of the
		Informix JDBC driver and is known to be fixed in version 9.4 of
		Informix and version 2.21 of the Informix JDBC driver.</p>

		<p><a href="#top">Top</a></p>

		<h1 class="question"><a name="faq8">I am using SQuirreL 2.x
		and when I connect to a database I get the following warning message:</a></h1>

		<pre>
    JRE/JDBC Version mismatch

    The driver being used ... is not JDBC N.N compliant. 
    You should consider getting a more recent version of this driver.
   
</pre>

		<div class="answer">It's telling you that your JRE version is
		much newer than your driver's supported JDBC version. In general, it's
		hard to tell how well tested an older driver is with a newer
		JVM(1.4+). The odds are good that the newer JVM wasn't available when
		the older driver was written. So the warning message is there to let
		you know that you aren't getting the most efficient use from SQuirreL
		2.x and your database driver. SQuirreL 2.x requires JVM 1.4 or higher
		so your choices are limited there. Upgrade your JDBC driver if
		possible - if not, then you can disable the warning. To disable it go
		to Global Preferences -&gt; General and uncheck the checkbox next to <b><i>Warning
		for JRE/JDBC Version Mismatch</i></b></div>

		<br>


		<p><a href="#top">Top</a></p>
		</td>
		<td class="body_right_border">&nbsp;</td>
	</tr>

	<tr>
		<td width='10' height='10'><img alt="border image" border="0"
			src="images/border_bl.gif" width="10" height="10"></td>
		<td width='100%' height='10'><img alt="border image" border="0"
			src="images/border_b.gif" width="100%" height="10"></td>
		<td width='10' height='10'><img alt="border image" border="0"
			src="images/border_br.gif" width="10" height="10"></td>
	</tr>
</table>

<p class="menu_divider">
<table summary="Plugin Answers" border="0" cellpadding="0"
	cellspacing="0" width="100%">
	<tr>
		<td width='10' height='10'><img alt="border image" border="0"
			src="images/border_tl.gif" width="10" height="10"></td>
		<td width='100%' height='10'><img alt="border image" border="0"
			src="images/border_t.gif" width="100%" height="10"></td>
		<td width='10' height='10'><img alt="border image" border="0"
			src="images/border_tr.gif" width="10" height="10"></td>
	</tr>

	<tr>
		<td class="body_left_border">&nbsp;</td>
		<td width='100%' bgcolor="white" valign="top">
		<h1 class="body">Answers - Plugins.</h1>

		<h1 class="question"><a name="plug0">How do I write a plugin?</a></h1>

		<p class="answer">There is some information in the document <a
			href="http://squirrel-sql.cvs.sourceforge.net/*checkout*/squirrel-sql/sql12/doc/plugins.html?revision=1.1">
		plugins.html</a> which you can find in the docs directory within your
		SQuirreL program directory. This document badly needs a lot of work
		and its on our todo list. You can also look at the existing plugins to
		see how they've done things.</p>

		<p class="answer">If you have an idea for a plugin just send a
		message to the SQuirreL Developers list giving a brief description.
		This helps to ensure that two people don't develop the same plugin.</p>

		<p><a href="#top">Top</a></p>

		<h1 class="question"><a name="plug1">What are these
		directories "Colin Bell" and "Johan Compagner" in the plugins
		directory?</a></h1>

		<p class="answer">Some people have reported these directories
		appearing when running JDK 1.3 on Windows 2000. It appears to be a
		problem with the Hotspot VM. Passing the -classic flag to the java
		executable fixes the problem - i.e.</p>

		<p class="code">java -classic -cp...</p>

		<p><a href="#top">Top</a></p>

		<h1 class="question"><a name="plug2">I can't see any "Look
		and Feel" files.</a></h1>

		<p class="answer">This can be caused by the <a href="#plug1">What
		are these directories "Colin Bell" and "Johan Compagner" in the
		plugins directory?</a> problem.</p>

		<p><a href="#top">Top</a></p>

		<h1 class="question"><a name="plug3">I get a
		java.lang.NoClassDefFoundError: org/w3c/dom/Node error when trying to
		validate SQL.</a></h1>

		<p class="answer">If you use the SQL Validator plugin with JDK 1.3
		you will need a JAXP 1.1 XML compliant parser such as <a
			href="http://xml.apache.org/dist/xerces-j/">xml-xerces</a> or the <a
			href="http://java.sun.com/xml/jaxp/index.html">JAXP 1.1 reference
		implementation</a>. Copy the jar files from your XML parser to the
		directory &lt;squirrel-sql&gt;/plugins/sqlval/lib. For xml-xerces this
		should be xerces.jar and for JAXP 1.1 reference implementation this
		should be crimson.jar and jaxp.jar.</p>

		<p><a href="#top">Top</a></p>
		</td>
		<td class="body_right_border">&nbsp;</td>
	</tr>

	<tr>
		<td width='10' height='10'><img alt="border image" border="0"
			src="images/border_bl.gif" width="10" height="10"></td>
		<td width='100%' height='10'><img alt="border image" border="0"
			src="images/border_b.gif" width="100%" height="10"></td>
		<td width='10' height='10'><img alt="border image" border="0"
			src="images/border_br.gif" width="10" height="10"></td>
	</tr>
</table>
</body>
</html>

